# -*- coding: utf-8 -*-
"""
Created on Wed Jul 22 22:58:18 2020

@author: freelon
"""

import pandas as pd

blm_dates = pd.read_csv('blm_dates.txt',header=None) #all you need is the tweet dates
blm_dates[0] = blm_dates[0].str[:10]
date_counts = blm_dates[0].value_counts()
date_counts = pd.DataFrame(list(zip(date_counts.index.values,
                                    date_counts)),
                           columns=['date','count'])
date_counts = date_counts.sort_values('date')
date_counts.to_csv('blm_tweets_by_date.csv',
                   index=False)